/*
 Navicat Premium Data Transfer

 Source Server         : an
 Source Server Type    : MySQL
 Source Server Version : 80032
 Source Host           : localhost:3306
 Source Schema         : calculator

 Target Server Type    : MySQL
 Target Server Version : 80032
 File Encoding         : 65001

 Date: 03/05/2023 20:59:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '管理員id',
  `userName` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `status` int DEFAULT '1',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
BEGIN;
INSERT INTO `t_admin` (`id`, `userName`, `password`, `phone`, `status`, `createTime`) VALUES (1, 'an', '123', '13534149323', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_resouce
-- ----------------------------
DROP TABLE IF EXISTS `t_resouce`;
CREATE TABLE `t_resouce` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `src` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `type` int DEFAULT NULL COMMENT '類型：\n\n1   壁紙\n2   按鍵音\n',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_resouce
-- ----------------------------
BEGIN;
INSERT INTO `t_resouce` (`id`, `title`, `src`, `desc`, `type`) VALUES (1, '道路', 'https://img0.baidu.com/it/u=1502872520,3974467197&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=889', '一直走下去', 1);
INSERT INTO `t_resouce` (`id`, `title`, `src`, `desc`, `type`) VALUES (2, '星空', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fc-ssl.duitang.com%2Fuploads%2Fitem%2F202004%2F12%2F20200412113955_gfcbn.thumb.1000_0.jpg&refer=http%3A%2F%2Fc-ssl.duitang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1685210092&t=07d522624352042c327339b50b5b04f1', '星空下的我們', 1);
INSERT INTO `t_resouce` (`id`, `title`, `src`, `desc`, `type`) VALUES (3, '默認按鍵音', '../sounds/click.wav', '一個普通的按鍵音哦﹣﹣', 2);
INSERT INTO `t_resouce` (`id`, `title`, `src`, `desc`, `type`) VALUES (6, '田野山間', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fc-ssl.duitang.com%2Fuploads%2Fitem%2F202002%2F22%2F20200222030751_efJQ2.thumb.400_0.jpeg&refer=http%3A%2F%2Fc-ssl.duitang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1685697146&t=fdf83d30cc949bf3aab1d27368e850fb', '沒什麼好說的', 1);
INSERT INTO `t_resouce` (`id`, `title`, `src`, `desc`, `type`) VALUES (7, '海洋', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fc-ssl.duitang.com%2Fuploads%2Fitem%2F201610%2F13%2F20161013194501_hVrNw.thumb.400_0.jpeg&refer=http%3A%2F%2Fc-ssl.duitang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1685697146&t=553a06c0d6cb74588cec79a2e786ec1f', '鯨魚', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
